﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="send.aspx.vb" Inherits="delivery_send" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
    <p>
        Queries:</p>
    <p>
        ?serial=00001&amp;storename=HO&amp;storeip=192.168.1.62&amp;guestname=Lois&amp;guestaddress=CAA&amp;contactno=0917&amp;order=1Chicken&amp;totalbill=250&amp;specialins=NONE&amp;changefor=1000&amp;datesent=20140610</p>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" DeleteCommand="DELETE FROM [delivery_items] WHERE [dKey] = @dKey" InsertCommand="INSERT INTO delivery_items(serial, storename, storeip, guestname, guestaddress, contactno, order_, totalbill, specialins, changefor, status, datesent, datedelivered, timestamp, sender) VALUES (@serial, @storename, @storeip, @guestname, @guestaddress, @contactno, @order_, @totalbill, @specialins, @changefor, @status, @datesent, @datedelivered, @timestamp, @sender)" SelectCommand="SELECT * FROM [delivery_items]" UpdateCommand="UPDATE [delivery_items] SET [serial] = @serial, [storename] = @storename, [storeip] = @storeip, [guestname] = @guestname, [guestaddress] = @guestaddress, [contactno] = @contactno, [order_] = @order_, [totalbill] = @totalbill, [specialins] = @specialins, [changefor] = @changefor, [status] = @status, [datesent] = @datesent, [datedelivered] = @datedelivered, [timestamp] = @timestamp WHERE [dKey] = @dKey">
        <DeleteParameters>
            <asp:Parameter Name="dKey" Type="Int64" />
        </DeleteParameters>
        <InsertParameters>
            <asp:QueryStringParameter Name="serial" QueryStringField="serial" Type="String" />
            <asp:QueryStringParameter Name="storename" QueryStringField="storename" Type="String" />
            <asp:QueryStringParameter Name="storeip" QueryStringField="storeip" Type="String" />
            <asp:QueryStringParameter Name="guestname" QueryStringField="guestname" Type="String" />
            <asp:QueryStringParameter Name="guestaddress" QueryStringField="guestaddress" Type="String" />
            <asp:QueryStringParameter Name="contactno" QueryStringField="contactno" Type="String" />
            <asp:QueryStringParameter Name="order_" QueryStringField="order" Type="String" />
            <asp:QueryStringParameter Name="totalbill" QueryStringField="totalbill" Type="Double" />
            <asp:QueryStringParameter Name="specialins" QueryStringField="specialins" Type="String" />
            <asp:QueryStringParameter Name="changefor" QueryStringField="changefor" Type="Double" />
            <asp:Parameter DefaultValue="OPEN" Name="status" Type="String" />
            <asp:QueryStringParameter Name="datesent" QueryStringField="datesent" Type="String" />
            <asp:Parameter DefaultValue="" Name="datedelivered" Type="String" />
            <asp:SessionParameter Name="timestamp" SessionField="timestamp" Type="String" />
            <asp:QueryStringParameter Name="sender" QueryStringField="sender" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="serial" Type="String" />
            <asp:Parameter Name="storename" Type="String" />
            <asp:Parameter Name="storeip" Type="String" />
            <asp:Parameter Name="guestname" Type="String" />
            <asp:Parameter Name="guestaddress" Type="String" />
            <asp:Parameter Name="contactno" Type="String" />
            <asp:Parameter Name="order_" Type="String" />
            <asp:Parameter Name="totalbill" Type="Double" />
            <asp:Parameter Name="specialins" Type="String" />
            <asp:Parameter Name="changefor" Type="Double" />
            <asp:Parameter Name="status" Type="String" />
            <asp:Parameter Name="datesent" Type="String" />
            <asp:Parameter Name="datedelivered" Type="String" />
            <asp:Parameter Name="timestamp" Type="String" />
            <asp:Parameter Name="dKey" Type="Int64" />
        </UpdateParameters>
    </asp:SqlDataSource>
</body>
</html>
